package com.climb.moive.dao;

import com.climb.moive.entity.Member;

import java.sql.SQLException;
import java.util.List;

public interface MemberDao {
    public void insert(Member member) throws SQLException;
    public void update(Member member) throws SQLException;

    public void delete(int id) throws SQLException;

    public Member findById(int id) throws SQLException;

    public Member findByPhone(String phone) throws  SQLException;

    public List<Member> findAll() throws SQLException;

    Integer count()throws SQLException;
    /**模糊查询用户姓名返回列表*/
    List<Member> findMembersByName(String name) throws SQLException;

    Member login(Member member) throws SQLException;
}